package com.guangyuan.network.dao.interfaces.sql;

public interface ProductAttrSql {
	public String insert="insert into product_attr(name, cn_name, description, gmt_create, gmt_modified, operator, product_group_id) values(?, ? ,?, current_timestamp, current_timestamp, ?, ?)";
	public String selectByProductGroupId = "select id, name, cn_name, description, operator, gmt_create, gmt_modified, product_group_id from product_attr where product_group_id = ?";
	public String update = "update product_attr set name=?, cn_name=?, description=?, operator=?, gmt_modified = current_timestamp where id=?";
	public String delete = "delete from product_attr where id=?";
}
